﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ConvertDataSet" targetNamespace="http://tempuri.org/ConvertDataSet.xsd" xmlns:mstns="http://tempuri.org/ConvertDataSet.xsd" xmlns="http://tempuri.org/ConvertDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="5" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="jus2007ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="jus2007ConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Big3.Hitbase.DataBaseEngine.Properties.Settings.GlobalReference.Default.jus2007ConnectionString1" Provider="Microsoft.SqlServerCe.Client.3.5" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="jus2007_emptyConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="jus2007_emptyConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Big3.Hitbase.DataBaseEngine.Properties.Settings.GlobalReference.Default.jus2007_emptyConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="leerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="leerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Big3.Hitbase.DataBaseEngine.Properties.Settings.GlobalReference.Default.leerConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="templateConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="templateConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Big3.Hitbase.DataBaseEngine.Properties.Settings.GlobalReference.Default.templateConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="templateConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="templateConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Big3.Hitbase.DataBaseEngine.Properties.Settings.GlobalReference.Default.templateConnectionString1" Provider="Microsoft.SqlServerCe.Client.3.5" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="templateConvertConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="templateConvertConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Big3.Hitbase.DataBaseEngine.Properties.Settings.GlobalReference.Default.templateConvertConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryTableAdapter" GeneratorDataComponentClassName="CategoryTableAdapter" Name="Category" UserDataComponentName="CategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Category] WHERE (([CategoryID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Category] ([CategoryID], [Name], [Order]) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [CategoryID], [Name], [Order] FROM [Category]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Category] SET [CategoryID] = @p1, [Name] = @p2, [Order] = @p3 WHERE (([CategoryID] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrackTableAdapter" GeneratorDataComponentClassName="TrackTableAdapter" Name="Track" UserDataComponentName="TrackTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Track" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Track] WHERE (([TrackID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Track] ([TrackID], [CDID], [ArtistID], [TrackNumber], [Title], [Length], [Bpm], [SoundFile], [Codes], [Comment], [Lyrics], [User1], [User2], [User3], [User4], [User5], [TrackFormat], [BitRate], [SampleRate], [Channels], [YearRecorded], [Checksum], [Rating], [CategoryID], [ComposerID], [Language]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtistID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bpm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoundFile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Codes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Lyrics" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackFormat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BitRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SampleRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Channels" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Checksum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ComposerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [TrackID], [CDID], [ArtistID], [TrackNumber], [Title], [Length], [Bpm], [SoundFile], [Codes], [Comment], [Lyrics], [User1], [User2], [User3], [User4], [User5], [TrackFormat], [BitRate], [SampleRate], [Channels], [YearRecorded], [Checksum], [Rating], [CategoryID], [ComposerID], [Language] FROM [Track]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Track] SET [TrackID] = @p1, [CDID] = @p2, [ArtistID] = @p3, [TrackNumber] = @p4, [Title] = @p5, [Length] = @p6, [Bpm] = @p7, [SoundFile] = @p8, [Codes] = @p9, [Comment] = @p10, [Lyrics] = @p11, [User1] = @p12, [User2] = @p13, [User3] = @p14, [User4] = @p15, [User5] = @p16, [TrackFormat] = @p17, [BitRate] = @p18, [SampleRate] = @p19, [Channels] = @p20, [YearRecorded] = @p21, [Checksum] = @p22, [Rating] = @p23, [CategoryID] = @p24, [ComposerID] = @p25, [Language] = @p26 WHERE (([TrackID] = @p27))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtistID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bpm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SoundFile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Codes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Lyrics" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackFormat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BitRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SampleRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Channels" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Checksum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ComposerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p27" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TrackID" DataSetColumn="TrackID" />
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
              <Mapping SourceColumn="ArtistID" DataSetColumn="ArtistID" />
              <Mapping SourceColumn="TrackNumber" DataSetColumn="TrackNumber" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Bpm" DataSetColumn="Bpm" />
              <Mapping SourceColumn="SoundFile" DataSetColumn="SoundFile" />
              <Mapping SourceColumn="Codes" DataSetColumn="Codes" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="Lyrics" DataSetColumn="Lyrics" />
              <Mapping SourceColumn="User1" DataSetColumn="User1" />
              <Mapping SourceColumn="User2" DataSetColumn="User2" />
              <Mapping SourceColumn="User3" DataSetColumn="User3" />
              <Mapping SourceColumn="User4" DataSetColumn="User4" />
              <Mapping SourceColumn="User5" DataSetColumn="User5" />
              <Mapping SourceColumn="TrackFormat" DataSetColumn="TrackFormat" />
              <Mapping SourceColumn="BitRate" DataSetColumn="BitRate" />
              <Mapping SourceColumn="SampleRate" DataSetColumn="SampleRate" />
              <Mapping SourceColumn="Channels" DataSetColumn="Channels" />
              <Mapping SourceColumn="YearRecorded" DataSetColumn="YearRecorded" />
              <Mapping SourceColumn="Checksum" DataSetColumn="Checksum" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="ComposerID" DataSetColumn="ComposerID" />
              <Mapping SourceColumn="Language" DataSetColumn="Language" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CodeTableAdapter" GeneratorDataComponentClassName="CodeTableAdapter" Name="Code" UserDataComponentName="CodeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Code" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Code] WHERE (([Letter] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Letter" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Code] ([Letter], [Description]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Letter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Letter], [Description] FROM [Code]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Code] SET [Letter] = @p1, [Description] = @p2 WHERE (([Letter] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Letter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Letter" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Letter" DataSetColumn="Letter" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DialogTableAdapter" GeneratorDataComponentClassName="DialogTableAdapter" Name="Dialog" UserDataComponentName="DialogTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Dialog" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Dialog] WHERE (([DialogID] = @p1) AND ((@p2 = 1 AND [CategoryID] IS NULL) OR ([CategoryID] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DialogID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Dialog] ([DialogID], [CategoryID], [DialogXML]) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DialogID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="DialogXML" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [DialogID], [CategoryID], [DialogXML] FROM [Dialog]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Dialog] SET [DialogID] = @p1, [CategoryID] = @p2, [DialogXML] = @p3 WHERE (([DialogID] = @p4) AND ((@p5 = 1 AND [CategoryID] IS NULL) OR ([CategoryID] = @p6)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DialogID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="DialogXML" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DialogID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DialogID" DataSetColumn="DialogID" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="DialogXML" DataSetColumn="DialogXML" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IdentityTableAdapter" GeneratorDataComponentClassName="IdentityTableAdapter" Name="Identity" UserDataComponentName="IdentityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="[Identity]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Identity] WHERE (([Identity] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Identity] ([Identity], [CDID]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Identity], [CDID] FROM [Identity]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Identity] SET [Identity] = @p1, [CDID] = @p2 WHERE (([Identity] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Identity" DataSetColumn="Identity" />
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IndexTableAdapter" GeneratorDataComponentClassName="IndexTableAdapter" Name="Index" UserDataComponentName="IndexTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="[Index]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Index] ([CDID], [Name], [Position]) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Position" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CDID, Name, Position
FROM            [Index]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Position" DataSetColumn="Position" />
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoanedCDTableAdapter" GeneratorDataComponentClassName="LoanedCDTableAdapter" Name="LoanedCD" UserDataComponentName="LoanedCDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="LoanedCD" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [LoanedCD] WHERE (([CDID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [LoanedCD] ([CDID], [Comment], [LoanedDate], [LoanedTo], [ReturnDate]) VALUES (@p1, @p2, @p3, @p4, @p5)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LoanedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoanedTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ReturnDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [CDID], [Comment], [LoanedDate], [LoanedTo], [ReturnDate] FROM [LoanedCD]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [LoanedCD] SET [CDID] = @p1, [Comment] = @p2, [LoanedDate] = @p3, [LoanedTo] = @p4, [ReturnDate] = @p5 WHERE (([CDID] = @p6))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LoanedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoanedTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ReturnDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="LoanedDate" DataSetColumn="LoanedDate" />
              <Mapping SourceColumn="LoanedTo" DataSetColumn="LoanedTo" />
              <Mapping SourceColumn="ReturnDate" DataSetColumn="ReturnDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MediumTableAdapter" GeneratorDataComponentClassName="MediumTableAdapter" Name="Medium" UserDataComponentName="MediumTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Medium" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Medium] WHERE (([MediumID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MediumID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Medium] ([MediumID], [Name], [Order]) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MediumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [MediumID], [Name], [Order] FROM [Medium]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Medium] SET [MediumID] = @p1, [Name] = @p2, [Order] = @p3 WHERE (([MediumID] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MediumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MediumID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MediumID" DataSetColumn="MediumID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ParticipantTableAdapter" GeneratorDataComponentClassName="ParticipantTableAdapter" Name="Participant" UserDataComponentName="ParticipantTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Participant" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Participant] WHERE (([ParticipantID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParticipantID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Participant] ([ParticipantID], [PersonGroupID], [RoleID], [CDID], [TrackNumber], [Comment]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParticipantID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ParticipantID], [PersonGroupID], [RoleID], [CDID], [TrackNumber], [Comment] FROM [Participant]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Participant] SET [ParticipantID] = @p1, [PersonGroupID] = @p2, [RoleID] = @p3, [CDID] = @p4, [TrackNumber] = @p5, [Comment] = @p6 WHERE (([ParticipantID] = @p7))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParticipantID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TrackNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParticipantID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ParticipantID" DataSetColumn="ParticipantID" />
              <Mapping SourceColumn="PersonGroupID" DataSetColumn="PersonGroupID" />
              <Mapping SourceColumn="RoleID" DataSetColumn="RoleID" />
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
              <Mapping SourceColumn="TrackNumber" DataSetColumn="TrackNumber" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PersonGroupTableAdapter" GeneratorDataComponentClassName="PersonGroupTableAdapter" Name="PersonGroup" UserDataComponentName="PersonGroupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="PersonGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [PersonGroup] WHERE (([PersonGroupID] = @p1) AND ([Name] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonGroupID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [PersonGroup] ([PersonGroupID], [Name], [SaveAs], [Type], [Sex], [Comment], [URL], [Country], [BirthDay], [DayOfDeath], [ImageFilename]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SaveAs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BirthDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DayOfDeath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImageFilename" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [PersonGroupID], [Name], [SaveAs], [Type], [Sex], [Comment], [URL], [Country], [BirthDay], [DayOfDeath], [ImageFilename] FROM [PersonGroup]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [PersonGroup] SET [PersonGroupID] = @p1, [Name] = @p2, [SaveAs] = @p3, [Type] = @p4, [Sex] = @p5, [Comment] = @p6, [URL] = @p7, [Country] = @p8, [BirthDay] = @p9, [DayOfDeath] = @p10, [ImageFilename] = @p11 WHERE (([PersonGroupID] = @p12) AND ([Name] = @p13))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SaveAs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BirthDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DayOfDeath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImageFilename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonGroupID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PersonGroupID" DataSetColumn="PersonGroupID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="SaveAs" DataSetColumn="SaveAs" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Sex" DataSetColumn="Sex" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="URL" DataSetColumn="URL" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="BirthDay" DataSetColumn="BirthDay" />
              <Mapping SourceColumn="DayOfDeath" DataSetColumn="DayOfDeath" />
              <Mapping SourceColumn="ImageFilename" DataSetColumn="ImageFilename" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProgramTableAdapter" GeneratorDataComponentClassName="ProgramTableAdapter" Name="Program" UserDataComponentName="ProgramTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Program" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Program] ([CDID], [Name], [Tracks], [IsStandard]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tracks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsStandard" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [CDID], [Name], [Tracks], [IsStandard] FROM [Program]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Tracks" DataSetColumn="Tracks" />
              <Mapping SourceColumn="IsStandard" DataSetColumn="IsStandard" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QueueTableAdapter" GeneratorDataComponentClassName="QueueTableAdapter" Name="Queue" UserDataComponentName="QueueTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Queue" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Queue] ([CDID], [Action], [Identity], [IdentityCDDB]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="IdentityCDDB" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [CDID], [Action], [Identity], [IdentityCDDB] FROM [Queue]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
              <Mapping SourceColumn="Action" DataSetColumn="Action" />
              <Mapping SourceColumn="Identity" DataSetColumn="Identity" />
              <Mapping SourceColumn="IdentityCDDB" DataSetColumn="IdentityCDDB" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="Role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Role] WHERE (([RoleID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Role] ([RoleID], [Name]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [RoleID], [Name] FROM [Role]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Role] SET [RoleID] = @p1, [Name] = @p2 WHERE (([RoleID] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoleID" DataSetColumn="RoleID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SetTableAdapter" GeneratorDataComponentClassName="SetTableAdapter" Name="Set" UserDataComponentName="SetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="leerConnectionString (Settings)" DbObjectName="[Set]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Set] WHERE (([SetID] = @p1) AND ((@p2 = 1 AND [Name] IS NULL) OR ([Name] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Set] ([SetID], [Name]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [SetID], [Name] FROM [Set]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Set] SET [SetID] = @p1, [Name] = @p2 WHERE (([SetID] = @p3) AND ((@p4 = 1 AND [Name] IS NULL) OR ([Name] = @p5)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SetID" DataSetColumn="SetID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CDTableAdapter" GeneratorDataComponentClassName="CDTableAdapter" Name="CD" UserDataComponentName="CDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="templateConvertConnectionString (Settings)" DbObjectName="CD" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [CD] WHERE (([CDID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [CD] ([Identity], [Length], [NumberOfTracks], [IsSampler], [SetNumber], [SetID], [ArtistID], [CategoryID], [MediumID], [Title], [Date], [ArchiveNumber], [Codes], [Comment], [User1], [User2], [User3], [User4], [User5], [Type], [YearRecorded], [Copyright], [FrontCover], [BackCover], [CDLabelCover], [Rating], [Label], [URL], [Price], [UPC], [IsOriginal], [ComposerID], [Location], [Language], [CDID]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfTracks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsSampler" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtistID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MediumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArchiveNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Codes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Copyright" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrontCover" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BackCover" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDLabelCover" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p27" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Label" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p28" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p29" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p30" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UPC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p31" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsOriginal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p32" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ComposerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p33" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p34" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p35" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Identity], [Length], [NumberOfTracks], [IsSampler], [SetNumber], [SetID], [ArtistID], [CategoryID], [MediumID], [Title], [Date], [ArchiveNumber], [Codes], [Comment], [User1], [User2], [User3], [User4], [User5], [Type], [YearRecorded], [Copyright], [FrontCover], [BackCover], [CDLabelCover], [Rating], [Label], [URL], [Price], [UPC], [IsOriginal], [ComposerID], [Location], [Language], [CDID] FROM [CD]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [CD] SET [Identity] = @p1, [Length] = @p2, [NumberOfTracks] = @p3, [IsSampler] = @p4, [SetNumber] = @p5, [SetID] = @p6, [ArtistID] = @p7, [CategoryID] = @p8, [MediumID] = @p9, [Title] = @p10, [Date] = @p11, [ArchiveNumber] = @p12, [Codes] = @p13, [Comment] = @p14, [User1] = @p15, [User2] = @p16, [User3] = @p17, [User4] = @p18, [User5] = @p19, [Type] = @p20, [YearRecorded] = @p21, [Copyright] = @p22, [FrontCover] = @p23, [BackCover] = @p24, [CDLabelCover] = @p25, [Rating] = @p26, [Label] = @p27, [URL] = @p28, [Price] = @p29, [UPC] = @p30, [IsOriginal] = @p31, [ComposerID] = @p32, [Location] = @p33, [Language] = @p34, [CDID] = @p35 WHERE (([CDID] = @p36))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfTracks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsSampler" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SetID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtistID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p8" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p9" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MediumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p10" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p11" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p12" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArchiveNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p13" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Codes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p14" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p15" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p16" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p17" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p18" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p19" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="User5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p20" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p21" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p22" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Copyright" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p23" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FrontCover" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p24" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BackCover" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p25" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CDLabelCover" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p26" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p27" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Label" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p28" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p29" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p30" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UPC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p31" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsOriginal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p32" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ComposerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p33" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p34" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p35" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p36" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CDID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Identity" DataSetColumn="Identity" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="NumberOfTracks" DataSetColumn="NumberOfTracks" />
              <Mapping SourceColumn="IsSampler" DataSetColumn="IsSampler" />
              <Mapping SourceColumn="SetNumber" DataSetColumn="SetNumber" />
              <Mapping SourceColumn="SetID" DataSetColumn="SetID" />
              <Mapping SourceColumn="ArtistID" DataSetColumn="ArtistID" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="MediumID" DataSetColumn="MediumID" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="ArchiveNumber" DataSetColumn="ArchiveNumber" />
              <Mapping SourceColumn="Codes" DataSetColumn="Codes" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="User1" DataSetColumn="User1" />
              <Mapping SourceColumn="User2" DataSetColumn="User2" />
              <Mapping SourceColumn="User3" DataSetColumn="User3" />
              <Mapping SourceColumn="User4" DataSetColumn="User4" />
              <Mapping SourceColumn="User5" DataSetColumn="User5" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="YearRecorded" DataSetColumn="YearRecorded" />
              <Mapping SourceColumn="Copyright" DataSetColumn="Copyright" />
              <Mapping SourceColumn="FrontCover" DataSetColumn="FrontCover" />
              <Mapping SourceColumn="BackCover" DataSetColumn="BackCover" />
              <Mapping SourceColumn="CDLabelCover" DataSetColumn="CDLabelCover" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="Label" DataSetColumn="Label" />
              <Mapping SourceColumn="URL" DataSetColumn="URL" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="UPC" DataSetColumn="UPC" />
              <Mapping SourceColumn="IsOriginal" DataSetColumn="IsOriginal" />
              <Mapping SourceColumn="ComposerID" DataSetColumn="ComposerID" />
              <Mapping SourceColumn="Location" DataSetColumn="Location" />
              <Mapping SourceColumn="Language" DataSetColumn="Language" />
              <Mapping SourceColumn="CDID" DataSetColumn="CDID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ConvertDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ConvertDataSet" msprop:Generator_DataSetName="ConvertDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Category" msprop:Generator_UserTableName="Category" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_RowClassName="CategoryRow" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvArgName="CategoryRowChangeEvent" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_TableVarName="tableCategory" msprop:Generator_RowDeletingName="CategoryRowDeleting" msprop:Generator_TablePropName="Category">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msprop:Generator_UserColumnName="CategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Order" msprop:Generator_UserColumnName="Order" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInTable="OrderColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Track" msprop:Generator_UserTableName="Track" msprop:Generator_RowDeletedName="TrackRowDeleted" msprop:Generator_RowChangedName="TrackRowChanged" msprop:Generator_RowClassName="TrackRow" msprop:Generator_RowChangingName="TrackRowChanging" msprop:Generator_RowEvArgName="TrackRowChangeEvent" msprop:Generator_RowEvHandlerName="TrackRowChangeEventHandler" msprop:Generator_TableClassName="TrackDataTable" msprop:Generator_TableVarName="tableTrack" msprop:Generator_RowDeletingName="TrackRowDeleting" msprop:Generator_TablePropName="Track">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TrackID" msprop:Generator_UserColumnName="TrackID" msprop:Generator_ColumnPropNameInRow="TrackID" msprop:Generator_ColumnVarNameInTable="columnTrackID" msprop:Generator_ColumnPropNameInTable="TrackIDColumn" type="xs:int" />
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ArtistID" msprop:Generator_UserColumnName="ArtistID" msprop:Generator_ColumnPropNameInRow="ArtistID" msprop:Generator_ColumnVarNameInTable="columnArtistID" msprop:Generator_ColumnPropNameInTable="ArtistIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TrackNumber" msprop:Generator_UserColumnName="TrackNumber" msprop:Generator_ColumnPropNameInRow="TrackNumber" msprop:Generator_ColumnVarNameInTable="columnTrackNumber" msprop:Generator_ColumnPropNameInTable="TrackNumberColumn" type="xs:int" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Length" msprop:Generator_UserColumnName="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_ColumnPropNameInTable="LengthColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Bpm" msprop:Generator_UserColumnName="Bpm" msprop:Generator_ColumnPropNameInRow="Bpm" msprop:Generator_ColumnVarNameInTable="columnBpm" msprop:Generator_ColumnPropNameInTable="BpmColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SoundFile" msprop:Generator_UserColumnName="SoundFile" msprop:Generator_ColumnPropNameInRow="SoundFile" msprop:Generator_ColumnVarNameInTable="columnSoundFile" msprop:Generator_ColumnPropNameInTable="SoundFileColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Codes" msprop:Generator_UserColumnName="Codes" msprop:Generator_ColumnPropNameInRow="Codes" msprop:Generator_ColumnVarNameInTable="columnCodes" msprop:Generator_ColumnPropNameInTable="CodesColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lyrics" msprop:Generator_UserColumnName="Lyrics" msprop:Generator_ColumnPropNameInRow="Lyrics" msprop:Generator_ColumnVarNameInTable="columnLyrics" msprop:Generator_ColumnPropNameInTable="LyricsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User1" msprop:Generator_UserColumnName="User1" msprop:Generator_ColumnPropNameInRow="User1" msprop:Generator_ColumnVarNameInTable="columnUser1" msprop:Generator_ColumnPropNameInTable="User1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User2" msprop:Generator_UserColumnName="User2" msprop:Generator_ColumnPropNameInRow="User2" msprop:Generator_ColumnVarNameInTable="columnUser2" msprop:Generator_ColumnPropNameInTable="User2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User3" msprop:Generator_UserColumnName="User3" msprop:Generator_ColumnPropNameInRow="User3" msprop:Generator_ColumnVarNameInTable="columnUser3" msprop:Generator_ColumnPropNameInTable="User3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User4" msprop:Generator_UserColumnName="User4" msprop:Generator_ColumnPropNameInRow="User4" msprop:Generator_ColumnVarNameInTable="columnUser4" msprop:Generator_ColumnPropNameInTable="User4Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User5" msprop:Generator_UserColumnName="User5" msprop:Generator_ColumnPropNameInRow="User5" msprop:Generator_ColumnVarNameInTable="columnUser5" msprop:Generator_ColumnPropNameInTable="User5Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrackFormat" msprop:Generator_UserColumnName="TrackFormat" msprop:Generator_ColumnPropNameInRow="TrackFormat" msprop:Generator_ColumnVarNameInTable="columnTrackFormat" msprop:Generator_ColumnPropNameInTable="TrackFormatColumn" type="xs:int" minOccurs="0" />
              <xs:element name="BitRate" msprop:Generator_UserColumnName="BitRate" msprop:Generator_ColumnPropNameInRow="BitRate" msprop:Generator_ColumnVarNameInTable="columnBitRate" msprop:Generator_ColumnPropNameInTable="BitRateColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SampleRate" msprop:Generator_UserColumnName="SampleRate" msprop:Generator_ColumnPropNameInRow="SampleRate" msprop:Generator_ColumnVarNameInTable="columnSampleRate" msprop:Generator_ColumnPropNameInTable="SampleRateColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Channels" msprop:Generator_UserColumnName="Channels" msprop:Generator_ColumnPropNameInRow="Channels" msprop:Generator_ColumnVarNameInTable="columnChannels" msprop:Generator_ColumnPropNameInTable="ChannelsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="YearRecorded" msprop:Generator_UserColumnName="YearRecorded" msprop:Generator_ColumnPropNameInRow="YearRecorded" msprop:Generator_ColumnVarNameInTable="columnYearRecorded" msprop:Generator_ColumnPropNameInTable="YearRecordedColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Checksum" msprop:Generator_UserColumnName="Checksum" msprop:Generator_ColumnPropNameInRow="Checksum" msprop:Generator_ColumnVarNameInTable="columnChecksum" msprop:Generator_ColumnPropNameInTable="ChecksumColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInTable="RatingColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CategoryID" msprop:Generator_UserColumnName="CategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ComposerID" msprop:Generator_UserColumnName="ComposerID" msprop:Generator_ColumnPropNameInRow="ComposerID" msprop:Generator_ColumnVarNameInTable="columnComposerID" msprop:Generator_ColumnPropNameInTable="ComposerIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Language" msprop:Generator_UserColumnName="Language" msprop:Generator_ColumnPropNameInRow="Language" msprop:Generator_ColumnVarNameInTable="columnLanguage" msprop:Generator_ColumnPropNameInTable="LanguageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Code" msprop:Generator_UserTableName="Code" msprop:Generator_RowDeletedName="CodeRowDeleted" msprop:Generator_RowChangedName="CodeRowChanged" msprop:Generator_RowClassName="CodeRow" msprop:Generator_RowChangingName="CodeRowChanging" msprop:Generator_RowEvArgName="CodeRowChangeEvent" msprop:Generator_RowEvHandlerName="CodeRowChangeEventHandler" msprop:Generator_TableClassName="CodeDataTable" msprop:Generator_TableVarName="tableCode" msprop:Generator_RowDeletingName="CodeRowDeleting" msprop:Generator_TablePropName="Code">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Letter" msprop:Generator_UserColumnName="Letter" msprop:Generator_ColumnPropNameInRow="Letter" msprop:Generator_ColumnVarNameInTable="columnLetter" msprop:Generator_ColumnPropNameInTable="LetterColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Dialog" msprop:Generator_UserTableName="Dialog" msprop:Generator_RowDeletedName="DialogRowDeleted" msprop:Generator_RowChangedName="DialogRowChanged" msprop:Generator_RowClassName="DialogRow" msprop:Generator_RowChangingName="DialogRowChanging" msprop:Generator_RowEvArgName="DialogRowChangeEvent" msprop:Generator_RowEvHandlerName="DialogRowChangeEventHandler" msprop:Generator_TableClassName="DialogDataTable" msprop:Generator_TableVarName="tableDialog" msprop:Generator_RowDeletingName="DialogRowDeleting" msprop:Generator_TablePropName="Dialog">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DialogID" msprop:Generator_UserColumnName="DialogID" msprop:Generator_ColumnPropNameInRow="DialogID" msprop:Generator_ColumnVarNameInTable="columnDialogID" msprop:Generator_ColumnPropNameInTable="DialogIDColumn" type="xs:int" />
              <xs:element name="CategoryID" msprop:Generator_UserColumnName="CategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DialogXML" msprop:Generator_UserColumnName="DialogXML" msprop:Generator_ColumnPropNameInRow="DialogXML" msprop:Generator_ColumnVarNameInTable="columnDialogXML" msprop:Generator_ColumnPropNameInTable="DialogXMLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Identity" msprop:Generator_UserTableName="Identity" msprop:Generator_RowDeletedName="IdentityRowDeleted" msprop:Generator_RowChangedName="IdentityRowChanged" msprop:Generator_RowClassName="IdentityRow" msprop:Generator_RowChangingName="IdentityRowChanging" msprop:Generator_RowEvArgName="IdentityRowChangeEvent" msprop:Generator_RowEvHandlerName="IdentityRowChangeEventHandler" msprop:Generator_TableClassName="IdentityDataTable" msprop:Generator_TableVarName="tableIdentity" msprop:Generator_RowDeletingName="IdentityRowDeleting" msprop:Generator_TablePropName="Identity">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Identity" msprop:Generator_UserColumnName="Identity" msprop:Generator_ColumnPropNameInRow="Identity" msprop:Generator_ColumnVarNameInTable="columnIdentity" msprop:Generator_ColumnPropNameInTable="IdentityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Index" msprop:Generator_UserTableName="Index" msprop:Generator_RowDeletedName="IndexRowDeleted" msprop:Generator_RowChangedName="IndexRowChanged" msprop:Generator_RowClassName="IndexRow" msprop:Generator_RowChangingName="IndexRowChanging" msprop:Generator_RowEvArgName="IndexRowChangeEvent" msprop:Generator_RowEvHandlerName="IndexRowChangeEventHandler" msprop:Generator_TableClassName="IndexDataTable" msprop:Generator_TableVarName="tableIndex" msprop:Generator_RowDeletingName="IndexRowDeleting" msprop:Generator_TablePropName="Index">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Position" msprop:Generator_UserColumnName="Position" msprop:Generator_ColumnPropNameInRow="Position" msprop:Generator_ColumnVarNameInTable="columnPosition" msprop:Generator_ColumnPropNameInTable="PositionColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LoanedCD" msprop:Generator_UserTableName="LoanedCD" msprop:Generator_RowDeletedName="LoanedCDRowDeleted" msprop:Generator_RowChangedName="LoanedCDRowChanged" msprop:Generator_RowClassName="LoanedCDRow" msprop:Generator_RowChangingName="LoanedCDRowChanging" msprop:Generator_RowEvArgName="LoanedCDRowChangeEvent" msprop:Generator_RowEvHandlerName="LoanedCDRowChangeEventHandler" msprop:Generator_TableClassName="LoanedCDDataTable" msprop:Generator_TableVarName="tableLoanedCD" msprop:Generator_RowDeletingName="LoanedCDRowDeleting" msprop:Generator_TablePropName="LoanedCD">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" />
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LoanedDate" msprop:Generator_UserColumnName="LoanedDate" msprop:Generator_ColumnPropNameInRow="LoanedDate" msprop:Generator_ColumnVarNameInTable="columnLoanedDate" msprop:Generator_ColumnPropNameInTable="LoanedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LoanedTo" msprop:Generator_UserColumnName="LoanedTo" msprop:Generator_ColumnPropNameInRow="LoanedTo" msprop:Generator_ColumnVarNameInTable="columnLoanedTo" msprop:Generator_ColumnPropNameInTable="LoanedToColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReturnDate" msprop:Generator_UserColumnName="ReturnDate" msprop:Generator_ColumnPropNameInRow="ReturnDate" msprop:Generator_ColumnVarNameInTable="columnReturnDate" msprop:Generator_ColumnPropNameInTable="ReturnDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Medium" msprop:Generator_UserTableName="Medium" msprop:Generator_RowDeletedName="MediumRowDeleted" msprop:Generator_RowChangedName="MediumRowChanged" msprop:Generator_RowClassName="MediumRow" msprop:Generator_RowChangingName="MediumRowChanging" msprop:Generator_RowEvArgName="MediumRowChangeEvent" msprop:Generator_RowEvHandlerName="MediumRowChangeEventHandler" msprop:Generator_TableClassName="MediumDataTable" msprop:Generator_TableVarName="tableMedium" msprop:Generator_RowDeletingName="MediumRowDeleting" msprop:Generator_TablePropName="Medium">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MediumID" msprop:Generator_UserColumnName="MediumID" msprop:Generator_ColumnPropNameInRow="MediumID" msprop:Generator_ColumnVarNameInTable="columnMediumID" msprop:Generator_ColumnPropNameInTable="MediumIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Order" msprop:Generator_UserColumnName="Order" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInTable="OrderColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Participant" msprop:Generator_UserTableName="Participant" msprop:Generator_RowDeletedName="ParticipantRowDeleted" msprop:Generator_RowChangedName="ParticipantRowChanged" msprop:Generator_RowClassName="ParticipantRow" msprop:Generator_RowChangingName="ParticipantRowChanging" msprop:Generator_RowEvArgName="ParticipantRowChangeEvent" msprop:Generator_RowEvHandlerName="ParticipantRowChangeEventHandler" msprop:Generator_TableClassName="ParticipantDataTable" msprop:Generator_TableVarName="tableParticipant" msprop:Generator_RowDeletingName="ParticipantRowDeleting" msprop:Generator_TablePropName="Participant">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ParticipantID" msprop:Generator_UserColumnName="ParticipantID" msprop:Generator_ColumnPropNameInRow="ParticipantID" msprop:Generator_ColumnVarNameInTable="columnParticipantID" msprop:Generator_ColumnPropNameInTable="ParticipantIDColumn" type="xs:int" />
              <xs:element name="PersonGroupID" msprop:Generator_UserColumnName="PersonGroupID" msprop:Generator_ColumnPropNameInRow="PersonGroupID" msprop:Generator_ColumnVarNameInTable="columnPersonGroupID" msprop:Generator_ColumnPropNameInTable="PersonGroupIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RoleID" msprop:Generator_UserColumnName="RoleID" msprop:Generator_ColumnPropNameInRow="RoleID" msprop:Generator_ColumnVarNameInTable="columnRoleID" msprop:Generator_ColumnPropNameInTable="RoleIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TrackNumber" msprop:Generator_UserColumnName="TrackNumber" msprop:Generator_ColumnPropNameInRow="TrackNumber" msprop:Generator_ColumnVarNameInTable="columnTrackNumber" msprop:Generator_ColumnPropNameInTable="TrackNumberColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PersonGroup" msprop:Generator_UserTableName="PersonGroup" msprop:Generator_RowDeletedName="PersonGroupRowDeleted" msprop:Generator_RowChangedName="PersonGroupRowChanged" msprop:Generator_RowClassName="PersonGroupRow" msprop:Generator_RowChangingName="PersonGroupRowChanging" msprop:Generator_RowEvArgName="PersonGroupRowChangeEvent" msprop:Generator_RowEvHandlerName="PersonGroupRowChangeEventHandler" msprop:Generator_TableClassName="PersonGroupDataTable" msprop:Generator_TableVarName="tablePersonGroup" msprop:Generator_RowDeletingName="PersonGroupRowDeleting" msprop:Generator_TablePropName="PersonGroup">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PersonGroupID" msprop:Generator_UserColumnName="PersonGroupID" msprop:Generator_ColumnPropNameInRow="PersonGroupID" msprop:Generator_ColumnVarNameInTable="columnPersonGroupID" msprop:Generator_ColumnPropNameInTable="PersonGroupIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SaveAs" msprop:Generator_UserColumnName="SaveAs" msprop:Generator_ColumnPropNameInRow="SaveAs" msprop:Generator_ColumnVarNameInTable="columnSaveAs" msprop:Generator_ColumnPropNameInTable="SaveAsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInTable="SexColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="URL" msprop:Generator_UserColumnName="URL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInTable="URLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BirthDay" msprop:Generator_UserColumnName="BirthDay" msprop:Generator_ColumnPropNameInRow="BirthDay" msprop:Generator_ColumnVarNameInTable="columnBirthDay" msprop:Generator_ColumnPropNameInTable="BirthDayColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DayOfDeath" msprop:Generator_UserColumnName="DayOfDeath" msprop:Generator_ColumnPropNameInRow="DayOfDeath" msprop:Generator_ColumnVarNameInTable="columnDayOfDeath" msprop:Generator_ColumnPropNameInTable="DayOfDeathColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ImageFilename" msprop:Generator_UserColumnName="ImageFilename" msprop:Generator_ColumnPropNameInRow="ImageFilename" msprop:Generator_ColumnVarNameInTable="columnImageFilename" msprop:Generator_ColumnPropNameInTable="ImageFilenameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Program" msprop:Generator_UserTableName="Program" msprop:Generator_RowDeletedName="ProgramRowDeleted" msprop:Generator_RowChangedName="ProgramRowChanged" msprop:Generator_RowClassName="ProgramRow" msprop:Generator_RowChangingName="ProgramRowChanging" msprop:Generator_RowEvArgName="ProgramRowChangeEvent" msprop:Generator_RowEvHandlerName="ProgramRowChangeEventHandler" msprop:Generator_TableClassName="ProgramDataTable" msprop:Generator_TableVarName="tableProgram" msprop:Generator_RowDeletingName="ProgramRowDeleting" msprop:Generator_TablePropName="Program">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tracks" msprop:Generator_UserColumnName="Tracks" msprop:Generator_ColumnPropNameInRow="Tracks" msprop:Generator_ColumnVarNameInTable="columnTracks" msprop:Generator_ColumnPropNameInTable="TracksColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsStandard" msprop:Generator_UserColumnName="IsStandard" msprop:Generator_ColumnPropNameInRow="IsStandard" msprop:Generator_ColumnVarNameInTable="columnIsStandard" msprop:Generator_ColumnPropNameInTable="IsStandardColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Queue" msprop:Generator_UserTableName="Queue" msprop:Generator_RowDeletedName="QueueRowDeleted" msprop:Generator_RowChangedName="QueueRowChanged" msprop:Generator_RowClassName="QueueRow" msprop:Generator_RowChangingName="QueueRowChanging" msprop:Generator_RowEvArgName="QueueRowChangeEvent" msprop:Generator_RowEvHandlerName="QueueRowChangeEventHandler" msprop:Generator_TableClassName="QueueDataTable" msprop:Generator_TableVarName="tableQueue" msprop:Generator_RowDeletingName="QueueRowDeleting" msprop:Generator_TablePropName="Queue">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Action" msprop:Generator_UserColumnName="Action" msprop:Generator_ColumnPropNameInRow="Action" msprop:Generator_ColumnVarNameInTable="columnAction" msprop:Generator_ColumnPropNameInTable="ActionColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Identity" msprop:Generator_UserColumnName="Identity" msprop:Generator_ColumnPropNameInRow="Identity" msprop:Generator_ColumnVarNameInTable="columnIdentity" msprop:Generator_ColumnPropNameInTable="IdentityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdentityCDDB" msprop:Generator_UserColumnName="IdentityCDDB" msprop:Generator_ColumnPropNameInRow="IdentityCDDB" msprop:Generator_ColumnVarNameInTable="columnIdentityCDDB" msprop:Generator_ColumnPropNameInTable="IdentityCDDBColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Role" msprop:Generator_UserTableName="Role" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowClassName="RoleRow" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_TablePropName="Role">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoleID" msprop:Generator_UserColumnName="RoleID" msprop:Generator_ColumnPropNameInRow="RoleID" msprop:Generator_ColumnVarNameInTable="columnRoleID" msprop:Generator_ColumnPropNameInTable="RoleIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Set" msprop:Generator_UserTableName="Set" msprop:Generator_RowDeletedName="SetRowDeleted" msprop:Generator_RowChangedName="SetRowChanged" msprop:Generator_RowClassName="SetRow" msprop:Generator_RowChangingName="SetRowChanging" msprop:Generator_RowEvArgName="SetRowChangeEvent" msprop:Generator_RowEvHandlerName="SetRowChangeEventHandler" msprop:Generator_TableClassName="SetDataTable" msprop:Generator_TableVarName="tableSet" msprop:Generator_RowDeletingName="SetRowDeleting" msprop:Generator_TablePropName="Set">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SetID" msprop:Generator_UserColumnName="SetID" msprop:Generator_ColumnPropNameInRow="SetID" msprop:Generator_ColumnVarNameInTable="columnSetID" msprop:Generator_ColumnPropNameInTable="SetIDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CD" msprop:Generator_UserTableName="CD" msprop:Generator_RowDeletedName="CDRowDeleted" msprop:Generator_RowChangedName="CDRowChanged" msprop:Generator_RowClassName="CDRow" msprop:Generator_RowChangingName="CDRowChanging" msprop:Generator_RowEvArgName="CDRowChangeEvent" msprop:Generator_RowEvHandlerName="CDRowChangeEventHandler" msprop:Generator_TableClassName="CDDataTable" msprop:Generator_TableVarName="tableCD" msprop:Generator_RowDeletingName="CDRowDeleting" msprop:Generator_TablePropName="CD">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Identity" msprop:Generator_UserColumnName="Identity" msprop:Generator_ColumnPropNameInRow="Identity" msprop:Generator_ColumnVarNameInTable="columnIdentity" msprop:Generator_ColumnPropNameInTable="IdentityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Length" msprop:Generator_UserColumnName="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_ColumnPropNameInTable="LengthColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NumberOfTracks" msprop:Generator_UserColumnName="NumberOfTracks" msprop:Generator_ColumnPropNameInRow="NumberOfTracks" msprop:Generator_ColumnVarNameInTable="columnNumberOfTracks" msprop:Generator_ColumnPropNameInTable="NumberOfTracksColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IsSampler" msprop:Generator_UserColumnName="IsSampler" msprop:Generator_ColumnPropNameInRow="IsSampler" msprop:Generator_ColumnVarNameInTable="columnIsSampler" msprop:Generator_ColumnPropNameInTable="IsSamplerColumn" type="xs:boolean" />
              <xs:element name="SetNumber" msprop:Generator_UserColumnName="SetNumber" msprop:Generator_ColumnPropNameInRow="SetNumber" msprop:Generator_ColumnVarNameInTable="columnSetNumber" msprop:Generator_ColumnPropNameInTable="SetNumberColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SetID" msprop:Generator_UserColumnName="SetID" msprop:Generator_ColumnPropNameInRow="SetID" msprop:Generator_ColumnVarNameInTable="columnSetID" msprop:Generator_ColumnPropNameInTable="SetIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ArtistID" msprop:Generator_UserColumnName="ArtistID" msprop:Generator_ColumnPropNameInRow="ArtistID" msprop:Generator_ColumnVarNameInTable="columnArtistID" msprop:Generator_ColumnPropNameInTable="ArtistIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CategoryID" msprop:Generator_UserColumnName="CategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MediumID" msprop:Generator_UserColumnName="MediumID" msprop:Generator_ColumnPropNameInRow="MediumID" msprop:Generator_ColumnVarNameInTable="columnMediumID" msprop:Generator_ColumnPropNameInTable="MediumIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArchiveNumber" msprop:Generator_UserColumnName="ArchiveNumber" msprop:Generator_ColumnPropNameInRow="ArchiveNumber" msprop:Generator_ColumnVarNameInTable="columnArchiveNumber" msprop:Generator_ColumnPropNameInTable="ArchiveNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Codes" msprop:Generator_UserColumnName="Codes" msprop:Generator_ColumnPropNameInRow="Codes" msprop:Generator_ColumnVarNameInTable="columnCodes" msprop:Generator_ColumnPropNameInTable="CodesColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870911" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User1" msprop:Generator_UserColumnName="User1" msprop:Generator_ColumnPropNameInRow="User1" msprop:Generator_ColumnVarNameInTable="columnUser1" msprop:Generator_ColumnPropNameInTable="User1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User2" msprop:Generator_UserColumnName="User2" msprop:Generator_ColumnPropNameInRow="User2" msprop:Generator_ColumnVarNameInTable="columnUser2" msprop:Generator_ColumnPropNameInTable="User2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User3" msprop:Generator_UserColumnName="User3" msprop:Generator_ColumnPropNameInRow="User3" msprop:Generator_ColumnVarNameInTable="columnUser3" msprop:Generator_ColumnPropNameInTable="User3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User4" msprop:Generator_UserColumnName="User4" msprop:Generator_ColumnPropNameInRow="User4" msprop:Generator_ColumnVarNameInTable="columnUser4" msprop:Generator_ColumnPropNameInTable="User4Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User5" msprop:Generator_UserColumnName="User5" msprop:Generator_ColumnPropNameInRow="User5" msprop:Generator_ColumnVarNameInTable="columnUser5" msprop:Generator_ColumnPropNameInTable="User5Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="YearRecorded" msprop:Generator_UserColumnName="YearRecorded" msprop:Generator_ColumnPropNameInRow="YearRecorded" msprop:Generator_ColumnVarNameInTable="columnYearRecorded" msprop:Generator_ColumnPropNameInTable="YearRecordedColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Copyright" msprop:Generator_UserColumnName="Copyright" msprop:Generator_ColumnPropNameInRow="Copyright" msprop:Generator_ColumnVarNameInTable="columnCopyright" msprop:Generator_ColumnPropNameInTable="CopyrightColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FrontCover" msprop:Generator_UserColumnName="FrontCover" msprop:Generator_ColumnPropNameInRow="FrontCover" msprop:Generator_ColumnVarNameInTable="columnFrontCover" msprop:Generator_ColumnPropNameInTable="FrontCoverColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BackCover" msprop:Generator_UserColumnName="BackCover" msprop:Generator_ColumnPropNameInRow="BackCover" msprop:Generator_ColumnVarNameInTable="columnBackCover" msprop:Generator_ColumnPropNameInTable="BackCoverColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CDLabelCover" msprop:Generator_UserColumnName="CDLabelCover" msprop:Generator_ColumnPropNameInRow="CDLabelCover" msprop:Generator_ColumnVarNameInTable="columnCDLabelCover" msprop:Generator_ColumnPropNameInTable="CDLabelCoverColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInTable="RatingColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Label" msprop:Generator_UserColumnName="Label" msprop:Generator_ColumnPropNameInRow="Label" msprop:Generator_ColumnVarNameInTable="columnLabel" msprop:Generator_ColumnPropNameInTable="LabelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="URL" msprop:Generator_UserColumnName="URL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInTable="URLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:int" minOccurs="0" />
              <xs:element name="UPC" msprop:Generator_UserColumnName="UPC" msprop:Generator_ColumnPropNameInRow="UPC" msprop:Generator_ColumnVarNameInTable="columnUPC" msprop:Generator_ColumnPropNameInTable="UPCColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsOriginal" msprop:Generator_UserColumnName="IsOriginal" msprop:Generator_ColumnPropNameInRow="IsOriginal" msprop:Generator_ColumnVarNameInTable="columnIsOriginal" msprop:Generator_ColumnPropNameInTable="IsOriginalColumn" type="xs:boolean" />
              <xs:element name="ComposerID" msprop:Generator_UserColumnName="ComposerID" msprop:Generator_ColumnPropNameInRow="ComposerID" msprop:Generator_ColumnVarNameInTable="columnComposerID" msprop:Generator_ColumnPropNameInTable="ComposerIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Language" msprop:Generator_UserColumnName="Language" msprop:Generator_ColumnPropNameInRow="Language" msprop:Generator_ColumnVarNameInTable="columnLanguage" msprop:Generator_ColumnPropNameInTable="LanguageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CDID" msprop:Generator_UserColumnName="CDID" msprop:Generator_ColumnPropNameInRow="CDID" msprop:Generator_ColumnVarNameInTable="columnCDID" msprop:Generator_ColumnPropNameInTable="CDIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Category" />
      <xs:field xpath="mstns:CategoryID" />
    </xs:unique>
    <xs:unique name="Track_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Track" />
      <xs:field xpath="mstns:TrackID" />
    </xs:unique>
    <xs:unique name="Code_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Code" />
      <xs:field xpath="mstns:Letter" />
    </xs:unique>
    <xs:unique name="Dialog_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:Dialog" />
      <xs:field xpath="mstns:CategoryID" />
    </xs:unique>
    <xs:unique name="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Dialog" />
      <xs:field xpath="mstns:DialogID" />
    </xs:unique>
    <xs:unique name="Identity_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Identity" />
      <xs:field xpath="mstns:Identity" />
    </xs:unique>
    <xs:unique name="LoanedCD_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LoanedCD" />
      <xs:field xpath="mstns:CDID" />
    </xs:unique>
    <xs:unique name="Medium_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Medium" />
      <xs:field xpath="mstns:MediumID" />
    </xs:unique>
    <xs:unique name="Participant_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Participant" />
      <xs:field xpath="mstns:ParticipantID" />
    </xs:unique>
    <xs:unique name="PersonGroup_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:PersonGroup" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="PersonGroup_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PersonGroup" />
      <xs:field xpath="mstns:PersonGroupID" />
    </xs:unique>
    <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:RoleID" />
    </xs:unique>
    <xs:unique name="Set_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:Set" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="Set_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Set" />
      <xs:field xpath="mstns:SetID" />
    </xs:unique>
    <xs:unique name="CD_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CD" />
      <xs:field xpath="mstns:CDID" />
    </xs:unique>
  </xs:element>
</xs:schema>